package com.purplesoft.zettl.DatabaseTables;

import android.provider.BaseColumns;

public class TblItems {

	public class Columns implements BaseColumns {
		// columns of table "tbl_Items"
		public static final String Item = "Item";
		public static final String ItemDescription = "Description";
		public static final String ItemImg = "ItemImg";
		public static final String ManufacturerID = "ManufacturerID";
		public static final String MeasureID = "MeasureID";
		public static final String Price = "Price";
		public static final String CategoryID = "CategoryID";
		public static final String Notes = "Notes";
		public static final String Created = "Created";
		public static final String Modified = "Modified";
	}

	// table name
	public static final String tableName = "tblItems";
	public static final String CONTENT_TYPE = "vnd.android.cursor.dir/com.purplesoft.zettl.tblItems";

	// SQL command to create table "tbl_Items"
	public static final String createTable = "CREATE TABLE " + tableName + "("
			+ Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ Columns.Item + " TEXT, " 
			+ Columns.ItemDescription + " TEXT, "
			+ Columns.ItemImg + " TEXT, " 
			+ Columns.ManufacturerID + " INTEGER, " 
			+ Columns.MeasureID + " INTEGER, " 
			+ Columns.Price + " REAL, " 
			+ Columns.CategoryID + " INTEGER, " 
			+ Columns.Notes	+ " TEXT, "
			+ Columns.Created	+ " TEXT, "
			+ Columns.Modified	+ " TEXT)";
}
